/***********************************************************
* Purpose : Get Answer by Question_ID
* Author : NuoiNV
* Date: 25/3/2012
* Description: Get Answer by Question_ID
*/
IF EXISTS ( SELECT * FROM SYSOBJECTS WHERE NAME = 'sp_GetAnswerbyQuestionID') 
BEGIN
	DROP PROC sp_GetAnswerbyQuestionID
END
GO
CREATE PROC sp_GetAnswerbyQuestionID
	@ID INT
AS
BEGIN
	SELECT * FROM Answer where Question_ID = @ID
END